package com.tabuto.jizy.dao.jdbc;

public class JDBCConstant {
	
	
	public final static String MYSQL_DB_NAME = "jizydb";
	public final static String MYSQL_DRIVER_NAME = "com.mysql.jdbc.Driver";
	public final static String MYSQL_USER_NAME = "jizyAdmin";
	public final static String MYSQL_PASSWORD = "passwd";
	

	public static String SQLITE_DB_FILE_PATH = JDBCConstant.class
			.getResource("/data/sqlite/contact.db").toString();

	public final static String SQL_P_INSERT_CONTACT = "INSERT INTO contacts (user_id, name, surname) VALUES (?, ?, ?)";
	
	public final static String SQL_P_INSERT_USER = "INSERT INTO user (username, password) VALUES (?, ?)";
	
	public final static String SQL_P_GET_ALL_CONTACT = "SELECT * FROM contacts WHERE user_id = ?";

}
